/*
 Navicat MySQL Data Transfer

 Source Server         : aliyun
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : 8.141.154.137:3306
 Source Schema         : admin

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 07/12/2021 17:24:39
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin_user
-- ----------------------------
DROP TABLE IF EXISTS `admin_user`;
CREATE TABLE `admin_user` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `admin_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pass_word` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `role_id` int DEFAULT NULL,
  `gender` tinyint DEFAULT NULL,
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `is_delete` tinyint DEFAULT '0',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `add_time` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of admin_user
-- ----------------------------
BEGIN;
INSERT INTO `admin_user` VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 1, 1, '18212345678', '', NULL, 0, '2021-12-07 16:48:50', '2021-12-07 16:03:54');
INSERT INTO `admin_user` VALUES (2, 'guest', 'e10adc3949ba59abbe56e057f20f883e', 2, 1, '18212345678', '', '游客', 0, '2021-12-07 16:20:20', '2021-12-07 16:20:20');
COMMIT;

-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `introduction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `cat_id` int DEFAULT '0',
  `tags` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `home_recommend` tinyint DEFAULT '1',
  `blogger_recommend` tinyint DEFAULT '1',
  `author` int DEFAULT '0',
  `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` tinyint DEFAULT '0',
  `is_delete` tinyint DEFAULT '0',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `add_time` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of article
-- ----------------------------
BEGIN;
INSERT INTO `article` VALUES (1, '比亚迪乘用车11月销量97242 同比增长84.1%', ' 12月3日，比亚迪发布旗下乘用车11月销量快报。报告显示，当月比亚迪乘用车全系销售97242辆，同比增长84.1%。其中，新能源销量同比暴涨252.7%、达90121。这也是截止至目前的中国新能源乘用车月销新纪录，至此，比亚迪2021年度累计销量达500922。', '<p><span style=\"color: rgb(0, 0, 0); font-family: Tahoma, Arial, &quot;宋 体&quot;; text-align: justify;\">&nbsp;12月3日，比亚迪发布旗下乘用车11月销量快报。报告显示，当月比亚迪乘用车全系销售97242辆，同比增长84.1%。其中，新能源销量同比暴涨252.7%、达90121。这也是截止至目前的中国新能源乘用车月销新纪录，至此，比亚迪2021年度累计销量达500922。</span></p><p><img src=\"http://r3h8rxmby.hb-bkt.clouddn.com/16388658385005\" style=\"max-width:50%;\"><br></p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\">在DM插混、EV纯电“两条腿、齐步走”战略之下，比亚迪依托众多领先技术，呈现“百花齐放、多点突破”，从旗舰车型到热门车系，销量全面走高，持续引领行业。月内，比亚迪DM-i持续带动DM车型的销量腾飞，同比大涨499.8%，共销售43984辆;与此同时，在e平台3.0和刀片电池等“黑科技”的助推下，EV再创新高，销售46137辆，同比增长153.2%。</p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>旗舰领衔，汉EV单车破万、唐DM全面颠覆</b></p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;汉再创新高、销售12841辆;其中汉EV单车型销售10021辆，是中国首款月销破万的纯电动中大型轿车，并有望冲击月度C级轿车冠军。作为比肩德系BBA的豪华中大型轿车，汉自2020年7月上市至今，累计销量已突破14万，成为自主豪华轿车的新典范。</p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;同期，全新一代唐销量达8125，同比翻番，显示出其强大的产品力。又大又省的唐DM-i，以其“快、省、静、顺、绿、大”的全面优势，特别是“百公里油耗仅需5.3L”这一超省油“大杀招”，成为20万级新能源SUV的天花板，全面颠覆20万级SUV市场。截止至10月份，唐DM已连续4个月杀入20万以上新能源SUV的TOP3行列。</p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\"><img src=\"http://r3h8rxmby.hb-bkt.clouddn.com/16388658281910\" style=\"max-width:50%;\"><br></p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\"><b>秦PLUS超2.8万破十年纪录，EV车型多点开花</b></p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11月，秦PLUS销量达28151，再创车型月销新高。在A级轿车这个中国乘用车最大细分市场，这是自2011年1月以来，中国自主品牌A级轿车首次突破月销2.8万的大关。另一方面，在此前的10月份秦PLUS就曾以25908的销量问鼎中国A级新能源轿车冠军，本次有望蝉联这一桂冠。</p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;具体到细分车型，秦PLUS DM-i销售18054辆。自上市以来，秦PLUS DM-i以“超省、超快、超长”的特点，直击用户需求，全方位满足不同的用车场景，凭借超强的实力，迅速赢得消费者青睐。</p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;与此同时，秦PLUS EV持续放量，销量首次破万、达10097辆，成为比亚迪向紧凑级纯电动车市场投放的又一爆款车型。</p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\">&nbsp;另一方面，得益于近期DM-i车型产能的持续爬坡，宋DM的销量都有着明显提升，11月销售15097辆，同比大涨1229.0%，向同级别合资SUV发起挑战。</p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;EV车型方面，迎合新生代对潮流设计、智能安全追求的元Pro，11月销售6521辆，在小型纯电SUV市场依然占据着领先地位。</p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;基于e平台3.0打造的首款量产车型、海洋系列的首款车型——海豚，月内销售8809辆。凭借着高颜值、大空间、低能耗的卖点，海豚上市后短时间内即取得了不俗的成绩，成为细分领域的最大黑马。</p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\">&nbsp; &nbsp; &nbsp; &nbsp;但比亚迪依然在持续发力。近期广州车展上，比亚迪“海洋网”亮相，并发布了海洋美学设计首款轿车巡洋舰05，以及“王朝网”下的2022款宋Pro DM-i;并在11月30日开启了宋Pro DM-i的预售，外界反响热烈，仅预售首日累计订单量就达18116，有望在后续持续带动比亚迪销量的走高，引领行业一路向前。<br></p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\"><b>以领先新能源技术，助力“为地球降温1℃”</b></p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;自3月份以来，比亚迪无论是乘用车大盘还是新能源，销量都保持着持续正增长态势、连创新高，实现了“九连增”;年内累销破50万，同比增长230.7%，远超行业同期，实力彰显“新能源汽车领导者”的地位。</p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;领先成绩的取得，离不开比亚迪长期以来对技术创新和绿色梦想的坚持。在此前第26届联合国气候变化大会(COP26)上，比亚迪零排放纯电动大巴被大会指定为全球领导人及公众官方接驳车辆和主会场展车;第四届中国国际进口博览会期间，比亚迪获颁国内首张SGS承诺碳中和符合声明证书，即是比亚迪在绿色可持续方面努力与实力的最佳写照。</p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;在全球“碳达峰、碳中和”背景下，比亚迪充分发挥在新能源领域独特优势，不断加码新能源汽车等绿色解决方案，为消费者创造更加美好的绿色出行新体验，助力“为地球降温1℃”。</p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\"><br></p>', 2, '2,1', 2, 2, 1, '16388658385005', 0, 0, '2021-12-07 16:35:58', '2021-12-07 16:35:34');
INSERT INTO `article` VALUES (2, '油价调整最新消息：汽柴油每升下调0.34/0.35元', ' 根据近期国际市场油价变化情况，按照现行成品油价格形成机制，自2021年12月3日24时起，国内汽、柴油价格每吨分别降低430元和415元。其中92号汽油每升下调0.34元；95号汽油每升下调0.36元；0号柴油每升下调0.35元。油价重返7元时代，此次也是今年年内油价最大降幅。', '<p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\">根据近期国际市场油价变化情况，按照现行成品油价格形成机制，自2021年12月3日24时起，国内汽、柴油价格每吨分别降低430元和415元。其中92号汽油每升下调0.34元；95号汽油每升下调0.36元；0号柴油每升下调0.35元。油价重返7元时代，此次也是今年年内油价最大降幅。</p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>2021下半年油价调整幅度趋势图：</b></p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\"><img src=\"//i.img16888.com/upload/Images/2021/12/2021120305182228089.jpg\" style=\"max-width:100%;\"><br></p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\"><b>2021下半年广东92号/95号油价走势：</b><br></p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\"><img src=\"https://i.img16888.com/upload/Images/2021/12/2021120305182228539.jpg\" style=\"max-width:100%;\"><b><br></b></p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\"><b>附：各省区市和中心城市汽、柴油最高零售价格表</b><br></p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\"><img src=\"https://i.img16888.com/upload/Images/2021/12/2021120305182221967.jpg\" style=\"max-width:100%;\"><b><br></b></p><p style=\"margin-top: 15px; margin-bottom: 0px; padding-right: 6px; padding-left: 6px; border: 0px; list-style: none; line-height: 28px; color: rgb(0, 0, 0); word-break: break-all; text-align: justify; font-family: Tahoma, Arial, &quot;宋 体&quot;;\"><br></p>', 1, '1', 2, 2, 2, '16388658385005', 0, 0, '2021-12-07 16:48:21', '2021-12-07 16:45:08');
COMMIT;

-- ----------------------------
-- Table structure for article_cat
-- ----------------------------
DROP TABLE IF EXISTS `article_cat`;
CREATE TABLE `article_cat` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` tinyint DEFAULT '0',
  `is_delete` tinyint DEFAULT '0',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `add_time` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of article_cat
-- ----------------------------
BEGIN;
INSERT INTO `article_cat` VALUES (1, '今日要闻', 0, 0, '2021-12-07 16:29:05', '2021-12-07 16:29:05');
INSERT INTO `article_cat` VALUES (2, '行业新闻', 0, 0, '2021-12-07 16:29:16', '2021-12-07 16:29:16');
COMMIT;

-- ----------------------------
-- Table structure for article_tags
-- ----------------------------
DROP TABLE IF EXISTS `article_tags`;
CREATE TABLE `article_tags` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tags_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` tinyint DEFAULT '0',
  `is_delete` tinyint DEFAULT '0',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `add_time` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of article_tags
-- ----------------------------
BEGIN;
INSERT INTO `article_tags` VALUES (1, '汽车', 0, 0, '2021-12-07 16:35:42', '2021-12-07 16:35:42');
INSERT INTO `article_tags` VALUES (2, '比亚迪', 0, 0, '2021-12-07 16:35:50', '2021-12-07 16:35:50');
COMMIT;

-- ----------------------------
-- Table structure for carousel
-- ----------------------------
DROP TABLE IF EXISTS `carousel`;
CREATE TABLE `carousel` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` int DEFAULT '0',
  `is_delete` tinyint DEFAULT '0',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `add_time` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of carousel
-- ----------------------------
BEGIN;
INSERT INTO `carousel` VALUES (1, 'aodi_car', '16388656657603', 'http://8.141.154.137/', 0, 0, '2021-12-07 16:28:08', '2021-12-07 16:28:08');
INSERT INTO `carousel` VALUES (2, 'audoa4_car', '16388656942434', 'http://8.141.154.137/', 0, 0, '2021-12-07 16:28:23', '2021-12-07 16:28:23');
INSERT INTO `carousel` VALUES (3, 'benchi_car', '16388657105418', 'http://8.141.154.137/', 0, 0, '2021-12-07 16:28:36', '2021-12-07 16:28:36');
COMMIT;

-- ----------------------------
-- Table structure for image
-- ----------------------------
DROP TABLE IF EXISTS `image`;
CREATE TABLE `image` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_delete` tinyint DEFAULT '0',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `add_time` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of image
-- ----------------------------
BEGIN;
INSERT INTO `image` VALUES (1, 'msld_car', '16388657854066', 0, '2021-12-07 16:29:50', '2021-12-07 16:29:50');
INSERT INTO `image` VALUES (2, 'lkss_car', '16388657976027', 0, '2021-12-07 16:30:02', '2021-12-07 16:30:02');
INSERT INTO `image` VALUES (3, 'kdlk_car', '16388658086176', 0, '2021-12-07 16:30:12', '2021-12-07 16:30:12');
INSERT INTO `image` VALUES (4, 'jeep_car', '16388658178929', 0, '2021-12-07 16:30:23', '2021-12-07 16:30:23');
INSERT INTO `image` VALUES (5, 'bsj_car', '16388658281910', 0, '2021-12-07 16:30:31', '2021-12-07 16:30:31');
INSERT INTO `image` VALUES (6, 'bmwz4_car', '16388658385005', 0, '2021-12-07 16:30:45', '2021-12-07 16:30:45');
INSERT INTO `image` VALUES (7, 'bmw_car', '16388658504039', 0, '2021-12-07 16:30:56', '2021-12-07 16:30:56');
COMMIT;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `p_id` int DEFAULT '0',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `href` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `target` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sort` int DEFAULT '0',
  `controller_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `action_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_delete` tinyint DEFAULT '0',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `add_time` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO `menu` VALUES (1, '后台管理', 'menu', 0, 'fa fa-address-book', NULL, '_self', 0, NULL, NULL, 0, '2021-12-04 17:04:07', '2021-11-28 10:31:13');
INSERT INTO `menu` VALUES (2, '系统设置', 'menu', 1, 'fa fa-cogs', NULL, '_self', 1000, NULL, NULL, 0, '2021-12-05 20:37:58', '2021-11-28 10:31:31');
INSERT INTO `menu` VALUES (3, '管理员', 'menu', 2, 'fa fa-user-plus', '/admin/admin_user', '_self', 999, 'AdminUserController', 'Index', 0, '2021-12-05 20:38:03', '2021-11-28 10:31:43');
INSERT INTO `menu` VALUES (4, '角色', 'menu', 2, 'fa fa-address-book', '/admin/role_list', '_self', NULL, 'RoleController', 'Index', 0, '2021-12-05 20:37:36', '2021-11-28 10:31:50');
INSERT INTO `menu` VALUES (5, '菜单', 'menu', 2, 'fa fa-book', '/admin/menu_list', '_self', 0, 'MenuController', 'MenuList', 0, '2021-12-04 17:04:10', '2021-11-28 10:50:32');
INSERT INTO `menu` VALUES (6, '图片列表', 'menu', 8, 'fa fa-file-image-o', '/admin/image_list', '_self', NULL, 'UploadImageController', 'Index', 0, '2021-12-05 20:37:33', '2021-11-28 10:58:28');
INSERT INTO `menu` VALUES (8, '图片管理', 'menu', 1, 'fa fa-line-chart', NULL, NULL, 8000, NULL, NULL, 0, '2021-12-05 20:38:25', '2021-12-01 19:09:24');
INSERT INTO `menu` VALUES (10, '管理员-添加', 'button', 3, NULL, NULL, NULL, 0, 'AdminUserController', 'AjaxAdd', 0, '2021-12-04 17:06:35', '2021-12-04 17:06:22');
INSERT INTO `menu` VALUES (11, '管理员-更新', 'button', 3, NULL, NULL, NULL, 0, 'AdminUserController', 'AjaxEdit', 0, '2021-12-04 17:15:57', '2021-12-04 17:15:27');
INSERT INTO `menu` VALUES (12, '管理员-删除', 'button', 3, NULL, NULL, NULL, 0, 'AdminUserController', 'AjaxDelete', 0, '2021-12-04 17:50:40', '2021-12-04 17:50:14');
INSERT INTO `menu` VALUES (13, '角色-添加', 'button', 4, NULL, NULL, NULL, 0, 'RoleController', 'AjaxAdd', 0, '2021-12-04 17:51:27', '2021-12-04 17:50:55');
INSERT INTO `menu` VALUES (14, '角色-更新', 'button', 4, NULL, NULL, NULL, 0, 'RoleController', 'AjaxEdit', 0, '2021-12-04 17:53:58', '2021-12-04 17:51:29');
INSERT INTO `menu` VALUES (15, '角色-删除', 'button', 4, NULL, NULL, NULL, 0, 'RoleController', 'AjaxDelete', 0, '2021-12-04 17:53:59', '2021-12-04 17:51:45');
INSERT INTO `menu` VALUES (16, '七牛云-上传图片', 'button', 6, NULL, NULL, NULL, 0, 'UploadImageController', 'AjaxUploadImage', 0, '2021-12-04 17:56:48', '2021-12-04 17:53:13');
INSERT INTO `menu` VALUES (17, '七牛云-删除', 'button', 6, NULL, NULL, NULL, 0, 'UploadImageController', 'AjaxImageDelete', 0, '2021-12-04 17:56:49', '2021-12-04 17:53:18');
INSERT INTO `menu` VALUES (18, '管理员-查看', 'button', 3, NULL, NULL, NULL, 0, 'AdminUserController', 'Index', 0, '2021-12-04 17:55:20', '2021-12-04 17:54:52');
INSERT INTO `menu` VALUES (19, '角色-查看', 'button', 4, NULL, NULL, NULL, 0, 'RoleController', 'Index', 0, '2021-12-04 17:55:43', '2021-12-04 17:55:38');
INSERT INTO `menu` VALUES (20, '七牛云-查看', 'button', 6, NULL, NULL, NULL, 0, 'UploadImageController', 'Index', 0, '2021-12-04 17:56:50', '2021-12-04 17:56:01');
INSERT INTO `menu` VALUES (22, '首页轮播图', 'menu', 8, 'fa fa-file-image-o', '/admin/carousel_list', '_self', 0, 'CarouselController', 'Index', 0, '2021-12-05 16:46:12', '2021-12-05 16:44:37');
INSERT INTO `menu` VALUES (23, '文章管理', 'menu', 1, 'fa fa-list-alt', '', NULL, 9000, NULL, NULL, 0, '2021-12-05 20:38:28', '2021-12-05 20:25:57');
INSERT INTO `menu` VALUES (24, '文章列表', 'menu', 23, 'fa fa-list', '/admin/article_list', NULL, 0, 'ArticleController', 'Index', 0, '2021-12-05 20:27:44', '2021-12-05 20:26:58');
INSERT INTO `menu` VALUES (25, '文章分类', 'menu', 23, 'fa fa-reorder', '/admin/article_cat_list', NULL, 0, 'ArticleCatController', 'Index', 0, '2021-12-05 20:34:45', '2021-12-05 20:28:31');
INSERT INTO `menu` VALUES (26, '文章标签', 'menu', 23, 'fa fa-tags', '/admin/article_tags_list', NULL, 0, 'ArticleTagsController', 'Index', 0, '2021-12-05 20:30:00', '2021-12-05 20:29:40');
INSERT INTO `menu` VALUES (27, '轮播图-查看', 'button', 22, NULL, NULL, NULL, 0, 'CarouselController', 'Index', 0, '2021-12-06 18:57:50', '2021-12-06 18:57:01');
INSERT INTO `menu` VALUES (28, '轮播图-添加', 'button', 22, NULL, NULL, NULL, 0, 'CarouselController', 'AjaxAddCarousel', 0, '2021-12-06 19:03:13', '2021-12-06 18:57:53');
INSERT INTO `menu` VALUES (29, '轮播图-编辑', 'button', 22, NULL, NULL, NULL, 0, 'CarouselController', 'AjaxEditCarousel', 0, '2021-12-06 19:03:13', '2021-12-06 18:58:02');
INSERT INTO `menu` VALUES (30, '轮播图-删除', 'button', 22, NULL, NULL, NULL, 0, 'CarouselController', 'AjaxDeleteCarousel', 0, '2021-12-06 19:03:14', '2021-12-06 18:58:12');
INSERT INTO `menu` VALUES (31, '文章-查看', 'button', 24, NULL, NULL, NULL, 0, 'ArticleController', 'Index', 0, '2021-12-06 19:06:33', '2021-12-06 18:58:50');
INSERT INTO `menu` VALUES (32, '文章-添加', 'button', 24, NULL, NULL, NULL, 0, 'ArticleController', 'AjaxAddArticle', 0, '2021-12-06 19:06:35', '2021-12-06 18:58:54');
INSERT INTO `menu` VALUES (33, '文章-编辑', 'button', 24, NULL, NULL, NULL, 0, 'ArticleController', 'AjaxEditArticle', 0, '2021-12-06 19:06:36', '2021-12-06 18:59:00');
INSERT INTO `menu` VALUES (34, '文章-删除', 'button', 24, NULL, NULL, NULL, 0, 'ArticleController', 'AjaxDeleteArticle', 0, '2021-12-06 19:06:38', '2021-12-06 18:59:06');
INSERT INTO `menu` VALUES (35, '文章目录-查看', 'button', 25, NULL, NULL, NULL, 0, 'ArticleCatController', 'Index', 0, '2021-12-06 19:03:17', '2021-12-06 18:59:13');
INSERT INTO `menu` VALUES (36, '文章目录-添加', 'button', 25, NULL, NULL, NULL, 0, 'ArticleCatController', 'AjaxAddArticleCat', 0, '2021-12-06 19:03:17', '2021-12-06 18:59:20');
INSERT INTO `menu` VALUES (37, '文章目录-编辑', 'button', 25, NULL, NULL, NULL, 0, 'ArticleCatController', 'AjaxEditArticleCat', 0, '2021-12-06 19:03:18', '2021-12-06 18:59:25');
INSERT INTO `menu` VALUES (38, '文章目录-删除', 'button', 25, NULL, NULL, NULL, 0, 'ArticleCatController', 'AjaxDeleteArticleCat', 0, '2021-12-06 19:03:18', '2021-12-06 18:59:29');
INSERT INTO `menu` VALUES (39, '文章标签-查看', 'button', 26, NULL, NULL, NULL, 0, 'ArticleTagsController', 'Index', 0, '2021-12-06 19:03:19', '2021-12-06 18:59:36');
INSERT INTO `menu` VALUES (40, '文章标签-添加', 'button', 26, NULL, NULL, NULL, 0, 'ArticleTagsController', 'AjaxAddArticleTags', 0, '2021-12-06 19:03:21', '2021-12-06 18:59:42');
INSERT INTO `menu` VALUES (41, '文章标签-编辑', 'button', 26, NULL, NULL, NULL, 0, 'ArticleTagsController', 'AjaxEditArticleTags', 0, '2021-12-06 19:03:22', '2021-12-06 18:59:47');
INSERT INTO `menu` VALUES (42, '文章标签-删除', 'button', 26, NULL, NULL, NULL, 0, 'ArticleTagsController', 'AjaxDeleteArticleTags', 0, '2021-12-06 19:03:23', '2021-12-06 18:59:52');
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `role_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `auth` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `is_delete` tinyint DEFAULT '0',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `add_time` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES (1, '超级管理员', 'All', '[]', 0, '2021-12-04 14:06:21', '2021-12-01 09:57:35');
INSERT INTO `role` VALUES (2, '管理员', '管理员', '[\"1\",\"23\",\"26\",\"39\",\"25\",\"35\",\"24\",\"31\",\"32\",\"33\",\"8\",\"22\",\"27\",\"6\",\"20\",\"2\",\"3\",\"18\",\"5\",\"4\",\"19\"]', 0, '2021-12-07 16:19:41', '2021-12-07 16:19:41');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
